www.gusucode.com > 帝国网站管理系统(帝国CMS) 6 > 帝国网站管理系统(帝国CMS) 6.5繁体UTF-8/upload/e/wap/list.php

    <?php
require("../class/connect.php");
require("../class/db_sql.php");
require("../class/q_functions.php");
require("../data/dbcache/class.php");
$link=db_connect();
$empire=new mysqlquery();
define('WapPage','list');
require("wapfun.php");

//欄目ID
$classid=(int)$_GET['classid'];
if(!$classid||!$class_r[$classid]['tbname'])
{
	DoWapShowMsg('您來自的鏈接不存在','index.php?style=$wapstyle');
}
$pagetitle=$class_r[$classid]['classname'];

$bclassid=(int)$_GET['bclassid'];
$search='';
$add='';
if($class_r[$classid]['islast'])
{
	$add.=" and classid='$classid'";
}
else
{
	$where=ReturnClass($class_r[$classid][sonclass]);
	$add.=" and (".$where.")";
}
$modid=$class_r[$classid][modid];
//優化
$yhid=$class_r[$classid][yhid];
$yhvar='qlist';
$yhadd='';
if($yhid)
{
	$yhadd=ReturnYhSql($yhid,$yhvar);
}
$search.="&amp;style=$wapstyle&amp;classid=$classid&amp;bclassid=$bclassid";

$page=intval($_GET['page']);
$line=$pr['waplistnum'];//每頁顯示記錄數
$offset=$page*$line;
$query="select ".ReturnSqlListF($modid)." from {$dbtbpre}ecms_".$class_r[$classid]['tbname']." where ".$yhadd."checked=1".$add;
$totalnum=intval($_GET['totalnum']);
if(empty($totalnum))
{
	$totalquery="select count(*) as total from {$dbtbpre}ecms_".$class_r[$classid]['tbname']." where ".$yhadd."checked=1".$add;
	$num=$empire->gettotal($totalquery);//取得總條數
}
else
{
	$num=$totalnum;
}
$search.="&amp;totalnum=$num";
//排序
if(empty($class_r[$classid][reorder]))
{
	$addorder="newstime desc";
}
else
{
	$addorder=$class_r[$classid][reorder];
}
$query.=" order by ".ReturnSetTopSql('list').$addorder." limit $offset,$line";
$sql=$empire->query($query);
$returnpage=DoWapListPage($num,$line,$page,$search);
//系統模型
$ret_r=ReturnAddF($modid,2);
require('template/'.$usewapstyle.'/list.temp.php');
db_close();
$empire=null;
?>